﻿# MySQL-Front 5.0  (Build 1.223)

/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE */;
/*!40101 SET SQL_MODE='' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES */;
/*!40103 SET SQL_NOTES='ON' */;


# Host: localhost    Database: klassenbuch
# ------------------------------------------------------
# Server version 5.0.51a

CREATE DATABASE `klassenbuch` /*!40100 DEFAULT CHARACTER SET latin1 */;
USE `klassenbuch`;

#
# Source for table kbo_abteilungen
#

CREATE TABLE `kbo_abteilungen` (
  `id` int(4) NOT NULL auto_increment,
  `abteilung` varchar(50) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=28 DEFAULT CHARSET=latin1;

#
# Dumping data for table kbo_abteilungen
#

INSERT INTO `kbo_abteilungen` VALUES (1,'IT');
INSERT INTO `kbo_abteilungen` VALUES (2,'Metall');
INSERT INTO `kbo_abteilungen` VALUES (3,'KFZ');
INSERT INTO `kbo_abteilungen` VALUES (4,'Chemie');
INSERT INTO `kbo_abteilungen` VALUES (7,'Brauer');
INSERT INTO `kbo_abteilungen` VALUES (10,'Fleischer');

#
# Source for table kbo_abteilungszuordnung
#

CREATE TABLE `kbo_abteilungszuordnung` (
  `id` int(4) NOT NULL auto_increment,
  `benutzer_id` int(4) NOT NULL,
  `abteilungs_id` int(4) NOT NULL,
  `leiter` int(1) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=131 DEFAULT CHARSET=latin1;

#
# Dumping data for table kbo_abteilungszuordnung
#

INSERT INTO `kbo_abteilungszuordnung` VALUES (34,97,0,0);
INSERT INTO `kbo_abteilungszuordnung` VALUES (40,98,0,0);
INSERT INTO `kbo_abteilungszuordnung` VALUES (41,66,3,0);
INSERT INTO `kbo_abteilungszuordnung` VALUES (114,94,7,0);
INSERT INTO `kbo_abteilungszuordnung` VALUES (115,24,7,1);
INSERT INTO `kbo_abteilungszuordnung` VALUES (126,94,1,1);
INSERT INTO `kbo_abteilungszuordnung` VALUES (127,24,1,1);
INSERT INTO `kbo_abteilungszuordnung` VALUES (128,123,1,0);
INSERT INTO `kbo_abteilungszuordnung` VALUES (129,95,1,0);
INSERT INTO `kbo_abteilungszuordnung` VALUES (130,11,1,0);

#
# Source for table kbo_adminvorgaben
#

CREATE TABLE `kbo_adminvorgaben` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `zensuren_use` int(1) unsigned default '1',
  `zensuren_see` int(1) unsigned default NULL,
  `unterrichtsinhalte_see` int(1) unsigned default NULL,
  `unterrichtsinhalte_use` int(1) unsigned default '1',
  `anwesenheit_see` int(1) unsigned default NULL,
  `anwesenheit_use` int(1) unsigned default '1',
  `timetable_use` int(1) default '1',
  `sonderspalte1_name` varchar(17) NOT NULL,
  `sonderspalte2_name` varchar(17) NOT NULL,
  `sonderspalte3_name` varchar(17) NOT NULL,
  `sonderspalte1_use` int(1) default NULL,
  `sonderspalte2_use` int(1) default NULL,
  `sonderspalte3_use` int(1) default NULL,
  `pupil_see` int(1) unsigned default '1',
  `profilbilder` int(1) default NULL,
  `foto_maxsize` int(7) NOT NULL default '102400',
  `schulname` varchar(256) NOT NULL,
  `email_kbo` varchar(256) NOT NULL,
  `email_schule` varchar(256) NOT NULL,
  `stundendauer` int(11) NOT NULL default '45',
  `pw_mindestlaenge` int(2) NOT NULL,
  `ssl_protection` int(1) default '0',
  `notice` int(1) NOT NULL default '1',
  `tempmarks` int(1) NOT NULL default '1',
  `tendenz` int(1) NOT NULL default '1',
  `note_best` tinyint(3) NOT NULL default '1',
  `note_worst` tinyint(3) NOT NULL default '6',
  `timetable_uselevel` int(1) NOT NULL default '1',
  `weekend` tinyint(1) NOT NULL default '0',
  `ihk_passwort` varchar(100) NOT NULL,
  `email_hausaufgaben` int(1) NOT NULL default '0',
  `rssfeed` int(1) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

#
# Dumping data for table kbo_adminvorgaben
#

INSERT INTO `kbo_adminvorgaben` VALUES (1,0,0,0,1,1,1,0,'Lernfeld','','',1,0,0,1,1,204800,'Berufskolleg Uerdingen Krefeld','kbo@bkukr.de','kbo@bkukr.de',45,4,0,1,1,0,15,1,0,0,'schnittstelle',0,1);

#
# Source for table kbo_anwesenheit
#

CREATE TABLE `kbo_anwesenheit` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `klasse_id` int(10) default NULL,
  `benutzer_id` int(10) unsigned default NULL,
  `dauer` int(10) unsigned default NULL,
  `grund` varchar(20) default NULL,
  `entschuldigt` int(10) unsigned default NULL,
  `verspaetung_min` int(4) default NULL,
  `anwesend` int(1) default NULL,
  `entlassen` int(1) default NULL,
  `vorzeitig_entlassen_time` time default NULL,
  `tag` int(2) default NULL,
  `monat` int(2) default NULL,
  `jahr` int(4) default NULL,
  `geaendert_benutzer_id` int(10) default NULL,
  `date_timestamp` int(12) NOT NULL,
  `bemerkung` varchar(255) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3186 DEFAULT CHARSET=latin1;

#
# Dumping data for table kbo_anwesenheit
#



#
# Source for table kbo_benutzer
#

CREATE TABLE `kbo_benutzer` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `vorname` varchar(30) default NULL,
  `nachname` varchar(50) default NULL,
  `geburtsdatum` int(11) default NULL,
  `strasse` varchar(80) default NULL,
  `hausnummer` varchar(5) default NULL,
  `plz` int(10) unsigned default NULL,
  `ort` varchar(80) default NULL,
  `telefonnummer` varchar(20) default NULL,
  `handynummer` varchar(25) default NULL,
  `betrieb` int(10) unsigned default NULL,
  `rechtelevel` int(2) unsigned default NULL,
  `bild` int(1) NOT NULL default '0',
  `email` varchar(150) default NULL,
  `konfession` int(10) unsigned default '1',
  `beruf` int(10) unsigned default NULL,
  `pin` varchar(32) default NULL,
  `passwort` varchar(32) default '57b78e38d88b429c4180ca09377c1a3c',
  `benutzername` varchar(50) default NULL,
  `ident` varchar(32) NOT NULL,
  `lastlogin` int(11) NOT NULL,
  `counter_logins` int(11) NOT NULL,
  `ausgeschult` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=132 DEFAULT CHARSET=latin1;

#
# Dumping data for table kbo_benutzer
#

INSERT INTO `kbo_benutzer` VALUES (1,'Herr','Admin',31532400,'Datacenter','5',12345,'Serverpark','keine Angabe','',0,3,1,'kbo@dieschule.de',6,0,'b59c67bf196a4758191e42f76670ceba','57b78e38d88b429c4180ca09377c1a3c','Admin','',1235310790,866,0);

#
# Source for table kbo_berufe
#

CREATE TABLE `kbo_berufe` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `berufsbezeichnung` varchar(50) default NULL,
  `fachrichtung` varchar(50) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=14 DEFAULT CHARSET=latin1;

#
# Dumping data for table kbo_berufe
#



#
# Source for table kbo_betriebe
#

CREATE TABLE `kbo_betriebe` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `betriebsname` varchar(100) default NULL,
  `strasse` varchar(80) default NULL,
  `hausnummer` varchar(5) default NULL,
  `plz` int(10) unsigned default NULL,
  `ort` varchar(80) default NULL,
  `telefonnummer` varchar(80) default NULL,
  `faxnummer` varchar(80) default NULL,
  `email` varchar(120) default NULL,
  `ansprechpartner` varchar(100) default NULL,
  `ansprechpartner_telefon` varchar(50) default NULL,
  `ansprechpartner_email` varchar(120) default NULL,
  `ihk_ident` varchar(100) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=latin1;

#
# Dumping data for table kbo_betriebe
#

INSERT INTO `kbo_betriebe` VALUES (1,'Deutsche Telekom AG','Jungfernweg','13',47799,'Krefeld','02151 123456','02151 123456','email@provider.de','Ulrich Karsch','Telefonmann','Emailmann','7654321234567');

#
# Source for table kbo_connectionkeys
#

CREATE TABLE `kbo_connectionkeys` (
  `id` int(11) NOT NULL auto_increment,
  `connectionkey` varchar(100) NOT NULL,
  `zeitstempel` varchar(20) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=95 DEFAULT CHARSET=utf8 COMMENT='enthält die zuletzt benutzten connectionkeys';


#
# Source for table kbo_endnoten
#

CREATE TABLE `kbo_endnoten` (
  `id` mediumint(9) NOT NULL auto_increment,
  `benutzer_id` mediumint(9) NOT NULL,
  `class_id` int(10) NOT NULL,
  `fach_id` mediumint(9) NOT NULL,
  `lehrer_id` mediumint(9) NOT NULL,
  `datum` datetime NOT NULL,
  `note` int(3) NOT NULL,
  `term` int(1) NOT NULL,
  `schoolyear` int(4) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=34 DEFAULT CHARSET=latin1;

#
# Dumping data for table kbo_endnoten
#


#
# Source for table kbo_endnoten_history
#

CREATE TABLE `kbo_endnoten_history` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `date` datetime NOT NULL,
  `schoolyear` int(4) unsigned NOT NULL,
  `teacher_id` int(10) unsigned NOT NULL,
  `class_id` int(10) NOT NULL,
  `course_id` int(10) NOT NULL,
  `mark_vars` text NOT NULL,
  PRIMARY KEY  (`id`),
  FULLTEXT KEY `mark_vars` (`mark_vars`)
) ENGINE=MyISAM AUTO_INCREMENT=27 DEFAULT CHARSET=latin1;

#
# Dumping data for table kbo_endnoten_history
#


#
# Source for table kbo_faecher
#

CREATE TABLE `kbo_faecher` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `fach` varchar(50) default NULL,
  `abteilungs_id` int(11) NOT NULL default '-1' COMMENT 'Jede Abteilung kann nun eine eigene Fächerliste pflegen. Fächer mit -1 sind abteilungsübergreifend',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=24 DEFAULT CHARSET=latin1;

#
# Dumping data for table kbo_faecher
#



#
# Source for table kbo_hilfe
#

CREATE TABLE `kbo_hilfe` (
  `id` tinyint(4) NOT NULL auto_increment,
  `titel` text NOT NULL,
  `text` text NOT NULL,
  PRIMARY KEY  (`id`),
  FULLTEXT KEY `titel` (`titel`,`text`)
) ENGINE=MyISAM AUTO_INCREMENT=10 DEFAULT CHARSET=latin1;

#
# Dumping data for table kbo_hilfe
#


#
# Source for table kbo_klassen
#

CREATE TABLE `kbo_klassen` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `klasse` varchar(15) default NULL,
  `abteilungs_id` int(4) NOT NULL,
  `einstellungsdatum` int(11) default NULL,
  `klassenlehrer` int(10) unsigned default NULL,
  `klassensprecher` int(10) unsigned default NULL,
  `klassenlehrer_vertreter` int(10) unsigned default NULL,
  `klassensprecher_vertreter` int(10) unsigned default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=125 DEFAULT CHARSET=latin1;

#
# Dumping data for table kbo_klassen
#


#
# Source for table kbo_klassengruppen
#

CREATE TABLE `kbo_klassengruppen` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `gruppe` varchar(45) NOT NULL,
  `abteilungs_id` int(11) NOT NULL default '-1' COMMENT 'Bei -1 steht die Gruppe allen Abteilungen zur Verfügung',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=latin1 COMMENT='Ermöglicht das Unterteilen einer Klasse in mehrere Gruppen (';

#
# Dumping data for table kbo_klassengruppen
#

INSERT INTO `kbo_klassengruppen` VALUES (1,'A',-1);
INSERT INTO `kbo_klassengruppen` VALUES (2,'B',-1);
INSERT INTO `kbo_klassengruppen` VALUES (3,'C',-1);
INSERT INTO `kbo_klassengruppen` VALUES (4,'D',-1);

#
# Source for table kbo_klassenzuordnung
#

CREATE TABLE `kbo_klassenzuordnung` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `benutzer_id` int(10) unsigned default NULL,
  `klassen_id` int(10) unsigned default NULL,
  `gruppen_id` int(11) NOT NULL default '-1' COMMENT 'Ein Schüler kann inneralb einer Klasse zu einer gruppe gehören',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=99 DEFAULT CHARSET=latin1;

#
# Dumping data for table kbo_klassenzuordnung
#



#
# Source for table kbo_konfessionen
#

CREATE TABLE `kbo_konfessionen` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `konfession` varchar(40) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=21 DEFAULT CHARSET=latin1;

#
# Dumping data for table kbo_konfessionen
#

INSERT INTO `kbo_konfessionen` VALUES (1,'keine Angabe');
INSERT INTO `kbo_konfessionen` VALUES (2,'evangelisch');
INSERT INTO `kbo_konfessionen` VALUES (5,'ohne Bekenntnis');
INSERT INTO `kbo_konfessionen` VALUES (6,'römisch katholisch');
INSERT INTO `kbo_konfessionen` VALUES (8,'römisch orthodox');
INSERT INTO `kbo_konfessionen` VALUES (9,'altkatholisch');
INSERT INTO `kbo_konfessionen` VALUES (10,'muslimisch');
INSERT INTO `kbo_konfessionen` VALUES (11,'jdisch');
INSERT INTO `kbo_konfessionen` VALUES (12,'buddhistisch');
INSERT INTO `kbo_konfessionen` VALUES (13,'hinduistisch');

#
# Source for table kbo_lehrerzuordnung
#

CREATE TABLE `kbo_lehrerzuordnung` (
  `lehrer_id` int(11) NOT NULL,
  `fach_id` int(11) NOT NULL,
  `klassen_id` int(11) NOT NULL,
  `plan_id` int(10) unsigned NOT NULL,
  UNIQUE KEY `lehrer_id` (`lehrer_id`,`fach_id`,`klassen_id`,`plan_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

#
# Dumping data for table kbo_lehrerzuordnung
#


#
# Source for table kbo_lerninhalte
#

CREATE TABLE `kbo_lerninhalte` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `tag` int(2) unsigned default NULL,
  `monat` int(2) unsigned default NULL,
  `jahr` int(4) unsigned default NULL,
  `klasse` int(3) unsigned default NULL,
  `stunde` int(2) unsigned default NULL,
  `thema` varchar(500) default NULL,
  `lehrer` int(4) unsigned default NULL,
  `hausaufgaben` varchar(500) default NULL,
  `bemerkungen` varchar(500) default NULL,
  `sonderspalte1` varchar(500) NOT NULL,
  `sonderspalte2` varchar(500) NOT NULL,
  `sonderspalte3` varchar(500) NOT NULL,
  `fach` int(2) unsigned default NULL,
  `gruppe` int(11) NOT NULL default '-1',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=294 DEFAULT CHARSET=latin1;

#
# Dumping data for table kbo_lerninhalte
#



#
# Source for table kbo_lerninhalte_archiv
#

CREATE TABLE `kbo_lerninhalte_archiv` (
  `id` int(10) NOT NULL auto_increment,
  `tag` int(2) NOT NULL,
  `monat` int(2) NOT NULL,
  `jahr` int(4) NOT NULL,
  `klasse` int(3) NOT NULL,
  `stunde` int(2) NOT NULL,
  `thema` varchar(500) NOT NULL,
  `lehrer` int(4) NOT NULL,
  `hausaufgaben` varchar(500) NOT NULL,
  `bemerkungen` varchar(500) NOT NULL,
  `sonderspalte1` varchar(500) NOT NULL,
  `sonderspalte2` varchar(500) NOT NULL,
  `sonderspalte3` varchar(500) NOT NULL,
  `fach` int(2) NOT NULL,
  `aenderungsdatum` int(10) NOT NULL,
  `geaendertvon` int(5) NOT NULL,
  `aenderungstyp` int(1) NOT NULL,
  `gruppe` int(11) NOT NULL default '-1',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=113 DEFAULT CHARSET=utf8 COMMENT='Archiv fr gelschte oder genderte Datenstze in kbo_le';

#
# Dumping data for table kbo_lerninhalte_archiv
#



#
# Source for table kbo_nachrichten
#

CREATE TABLE `kbo_nachrichten` (
  `nachricht_id` int(10) NOT NULL auto_increment,
  `empfaenger` int(10) NOT NULL,
  `titel` varchar(150) NOT NULL,
  `text` text NOT NULL,
  `unread` int(1) NOT NULL default '1',
  `datum` datetime NOT NULL,
  PRIMARY KEY  (`nachricht_id`),
  FULLTEXT KEY `text` (`text`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=latin1 COMMENT='Hier sind alle Nachrichten des System gespeichert';

#
# Dumping data for table kbo_nachrichten
#


#
# Source for table kbo_nachrichten_typen
#

CREATE TABLE `kbo_nachrichten_typen` (
  `id` int(11) NOT NULL auto_increment,
  `titel` varchar(150) NOT NULL,
  `text` text NOT NULL,
  PRIMARY KEY  (`id`),
  FULLTEXT KEY `text` (`text`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=latin1 COMMENT='Speicherung von Mitteilungen falls mehrere Empfaenger.';

#
# Dumping data for table kbo_nachrichten_typen
#


#
# Source for table kbo_quartalsnoten
#

CREATE TABLE `kbo_quartalsnoten` (
  `id` mediumint(9) NOT NULL auto_increment,
  `benutzer_id` mediumint(9) NOT NULL,
  `class_id` int(10) NOT NULL,
  `fach_id` mediumint(9) NOT NULL,
  `lehrer_id` mediumint(9) NOT NULL,
  `datum` datetime NOT NULL,
  `note` int(3) NOT NULL,
  `quartal` int(1) NOT NULL default '1',
  `schoolyear` int(4) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=264 DEFAULT CHARSET=latin1 COMMENT='Hier werden die Noten des Halbjahres 1 und 2 gespeichert';

#
# Dumping data for table kbo_quartalsnoten
#


#
# Source for table kbo_rechte
#

CREATE TABLE `kbo_rechte` (
  `id` int(11) NOT NULL auto_increment,
  `rechtelevel` int(2) unsigned NOT NULL,
  `bezeichnung` varchar(64) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;

#
# Dumping data for table kbo_rechte
#

INSERT INTO `kbo_rechte` VALUES (1,0,'Gast');
INSERT INTO `kbo_rechte` VALUES (2,1,'Schüler');
INSERT INTO `kbo_rechte` VALUES (3,2,'Lehrer');
INSERT INTO `kbo_rechte` VALUES (4,3,'Administrator');
INSERT INTO `kbo_rechte` VALUES (5,4,'Betrieb');

#
# Source for table kbo_schuljahre
#

CREATE TABLE `kbo_schuljahre` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `anfang` int(11) NOT NULL,
  `ende` int(11) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=12 DEFAULT CHARSET=latin1 COMMENT='Speicherung der Schuljahre';

#
# Dumping data for table kbo_schuljahre
#

INSERT INTO `kbo_schuljahre` VALUES (7,1156892461,1183158061);
INSERT INTO `kbo_schuljahre` VALUES (11,1216422061,1250636461);

#
# Source for table kbo_sessions
#

CREATE TABLE `kbo_sessions` (
  `id` mediumint(9) NOT NULL auto_increment,
  `phpsessid` varchar(100) NOT NULL,
  `remote_addr` varchar(40) NOT NULL,
  `sess_id` mediumint(9) NOT NULL,
  `session` text NOT NULL,
  PRIMARY KEY  (`id`),
  FULLTEXT KEY `session` (`session`)
) ENGINE=MyISAM AUTO_INCREMENT=1254 DEFAULT CHARSET=latin1 COMMENT='Mit dieser Tabelle kann spaeter die Session geprueft werden';

#
# Dumping data for table kbo_sessions
#

#
# Source for table kbo_stundenplan
#

CREATE TABLE `kbo_stundenplan` (
  `id` int(11) NOT NULL auto_increment,
  `jahr` varchar(4) NOT NULL,
  `klassen_id` tinyint(4) NOT NULL,
  `active` int(1) NOT NULL default '1',
  PRIMARY KEY  (`id`),
  KEY `jahr` (`jahr`,`klassen_id`,`active`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;

#
# Dumping data for table kbo_stundenplan
#

INSERT INTO `kbo_stundenplan` VALUES (5,'2006',2,1);

#
# Source for table kbo_stundenplan_changinginterval
#

CREATE TABLE `kbo_stundenplan_changinginterval` (
  `id` int(10) NOT NULL auto_increment,
  `plan_id1` int(10) NOT NULL,
  `plan_id2` int(10) NOT NULL,
  `intervall` int(2) NOT NULL,
  `lastchangeweek` int(2) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1 COMMENT='Speicherung der Wochenintervalle wann ein Stundenplan geaend';

#
# Dumping data for table kbo_stundenplan_changinginterval
#


#
# Source for table kbo_stundenplan_faecher
#

CREATE TABLE `kbo_stundenplan_faecher` (
  `id` int(11) NOT NULL auto_increment,
  `plan_id` int(11) NOT NULL,
  `stunde` int(3) NOT NULL,
  `fach_id` int(11) NOT NULL,
  `lehrer_id` mediumint(9) NOT NULL,
  `tag_id` int(11) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=latin1;

#
# Dumping data for table kbo_stundenplan_faecher
#

INSERT INTO `kbo_stundenplan_faecher` VALUES (10,5,1,1,24,1);

#
# Source for table kbo_tage
#

CREATE TABLE `kbo_tage` (
  `id` tinyint(4) NOT NULL auto_increment,
  `name` char(10) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=latin1;

#
# Dumping data for table kbo_tage
#


#
# Source for table kbo_unterricht_zeiten
#

CREATE TABLE `kbo_unterricht_zeiten` (
  `id` int(11) NOT NULL auto_increment,
  `stunde` int(11) NOT NULL,
  `von` time NOT NULL,
  `bis` time NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=29 DEFAULT CHARSET=latin1 PACK_KEYS=1;

#
# Dumping data for table kbo_unterricht_zeiten
#

INSERT INTO `kbo_unterricht_zeiten` VALUES (1,1,'07:30:00','08:15:00');
INSERT INTO `kbo_unterricht_zeiten` VALUES (2,2,'08:15:00','09:00:00');
INSERT INTO `kbo_unterricht_zeiten` VALUES (3,3,'09:15:00','10:00:00');
INSERT INTO `kbo_unterricht_zeiten` VALUES (4,4,'10:00:00','10:45:00');
INSERT INTO `kbo_unterricht_zeiten` VALUES (5,5,'11:00:00','11:45:00');
INSERT INTO `kbo_unterricht_zeiten` VALUES (6,6,'11:45:00','12:30:00');
INSERT INTO `kbo_unterricht_zeiten` VALUES (7,7,'12:45:00','13:30:00');
INSERT INTO `kbo_unterricht_zeiten` VALUES (8,8,'13:30:00','14:15:00');
INSERT INTO `kbo_unterricht_zeiten` VALUES (9,9,'14:30:00','15:15:00');
INSERT INTO `kbo_unterricht_zeiten` VALUES (10,10,'15:15:00','16:00:00');

#
# Source for table kbo_wochentage
#

CREATE TABLE `kbo_wochentage` (
  `id` tinyint(4) NOT NULL auto_increment,
  `name` char(10) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=latin1;

#
# Dumping data for table kbo_wochentage
#

INSERT INTO `kbo_wochentage` VALUES (1,'Montag');
INSERT INTO `kbo_wochentage` VALUES (2,'Dienstag');
INSERT INTO `kbo_wochentage` VALUES (3,'Mittwoch');
INSERT INTO `kbo_wochentage` VALUES (4,'Donnerstag');
INSERT INTO `kbo_wochentage` VALUES (5,'Freitag');
INSERT INTO `kbo_wochentage` VALUES (6,'Samstag');
INSERT INTO `kbo_wochentage` VALUES (7,'Sonntag');

#
# Source for table kbo_zensuren_quartal
#

CREATE TABLE `kbo_zensuren_quartal` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `benutzer_id` int(10) unsigned default NULL,
  `klassen_id` int(11) NOT NULL,
  `fach_id` int(3) unsigned default NULL,
  `note` int(10) unsigned default NULL,
  `lehrer_id` int(10) unsigned default NULL,
  `tendenz` varchar(1) default NULL,
  `quartal` int(1) unsigned default NULL,
  `jahr` int(4) unsigned default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;

#
# Dumping data for table kbo_zensuren_quartal
#


#
# Source for table kbo_zwischennoten
#

CREATE TABLE `kbo_zwischennoten` (
  `id` int(10) NOT NULL auto_increment,
  `datum` datetime NOT NULL,
  `schueler_id` int(10) NOT NULL,
  `class_id` int(10) NOT NULL,
  `lehrer_id` int(10) NOT NULL,
  `fach_id` int(10) NOT NULL,
  `art_id` tinyint(4) NOT NULL,
  `note` tinyint(4) NOT NULL,
  `tendenz` varchar(1) default NULL,
  `bemerkung` text NOT NULL,
  `schoolyear` int(4) NOT NULL,
  PRIMARY KEY  (`id`),
  FULLTEXT KEY `bemerkung` (`bemerkung`)
) ENGINE=MyISAM AUTO_INCREMENT=57 DEFAULT CHARSET=latin1 COMMENT='Hier werden alle Zwischennoten gespeichert';

#
# Dumping data for table kbo_zwischennoten
#


#
# Source for table kbo_zwischennoten_arten
#

CREATE TABLE `kbo_zwischennoten_arten` (
  `id` tinyint(4) NOT NULL auto_increment,
  `art` varchar(50) default NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `art` (`art`)
) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=latin1;

#
# Dumping data for table kbo_zwischennoten_arten
#

INSERT INTO `kbo_zwischennoten_arten` VALUES (1,'Klausur');
INSERT INTO `kbo_zwischennoten_arten` VALUES (2,'Test');
INSERT INTO `kbo_zwischennoten_arten` VALUES (3,'mündlich');


#
# Source for table kbo_zwischennoten_history
#

CREATE TABLE `kbo_zwischennoten_history` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `date` datetime NOT NULL,
  `schoolyear` int(4) unsigned NOT NULL,
  `teacher_id` int(10) unsigned NOT NULL,
  `class_id` int(10) NOT NULL,
  `course_id` int(10) NOT NULL,
  `action` varchar(50) NOT NULL,
  `mark_vars` text NOT NULL,
  PRIMARY KEY  (`id`),
  FULLTEXT KEY `mark_vars` (`mark_vars`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;

#
# Dumping data for table kbo_zwischennoten_history
#


/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
